--
-- PostgreSQL database dump
--

-- Started on 2013-08-08 06:43:19

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- TOC entry 1890 (class 1262 OID 33032)
-- Name: cms_development; Type: DATABASE; Schema: -; Owner: postgres
--

CREATE DATABASE cms_development WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'Spanish_Bolivarian Republic of Venezuela.1252' LC_CTYPE = 'Spanish_Bolivarian Republic of Venezuela.1252';


ALTER DATABASE cms_development OWNER TO postgres;

\connect cms_development

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- TOC entry 496 (class 2612 OID 16386)
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: postgres
--

CREATE PROCEDURAL LANGUAGE plpgsql;


ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO postgres;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 140 (class 1259 OID 33033)
-- Dependencies: 6
-- Name: gallery_element; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE gallery_element (
    element_id integer NOT NULL,
    sec_id integer,
    element_order integer
);


ALTER TABLE public.gallery_element OWNER TO postgres;

--
-- TOC entry 141 (class 1259 OID 33036)
-- Dependencies: 6 140
-- Name: GALLERY_ELEMENT_ELEMENT_ID_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE "GALLERY_ELEMENT_ELEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."GALLERY_ELEMENT_ELEMENT_ID_seq" OWNER TO postgres;

--
-- TOC entry 1893 (class 0 OID 0)
-- Dependencies: 141
-- Name: GALLERY_ELEMENT_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE "GALLERY_ELEMENT_ELEMENT_ID_seq" OWNED BY gallery_element.element_id;


--
-- TOC entry 1894 (class 0 OID 0)
-- Dependencies: 141
-- Name: GALLERY_ELEMENT_ELEMENT_ID_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('"GALLERY_ELEMENT_ELEMENT_ID_seq"', 8, true);


--
-- TOC entry 142 (class 1259 OID 33038)
-- Dependencies: 6
-- Name: applications; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE applications (
    app_id integer NOT NULL,
    image_id integer NOT NULL,
    user_id integer NOT NULL,
    app_description text,
    app_name text NOT NULL,
    app_version text NOT NULL,
    app_date_created date NOT NULL,
    app_date_updated date
);


ALTER TABLE public.applications OWNER TO postgres;

--
-- TOC entry 143 (class 1259 OID 33044)
-- Dependencies: 142 6
-- Name: applications_app_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE applications_app_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.applications_app_id_seq OWNER TO postgres;

--
-- TOC entry 1895 (class 0 OID 0)
-- Dependencies: 143
-- Name: applications_app_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE applications_app_id_seq OWNED BY applications.app_id;


--
-- TOC entry 1896 (class 0 OID 0)
-- Dependencies: 143
-- Name: applications_app_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('applications_app_id_seq', 13, true);


--
-- TOC entry 144 (class 1259 OID 33046)
-- Dependencies: 6
-- Name: element_text; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE element_text (
    element_id integer NOT NULL,
    sec_id integer NOT NULL,
    element_order integer NOT NULL,
    text_content text NOT NULL
);


ALTER TABLE public.element_text OWNER TO postgres;

--
-- TOC entry 145 (class 1259 OID 33052)
-- Dependencies: 144 6
-- Name: element_text_element_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE element_text_element_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.element_text_element_id_seq OWNER TO postgres;

--
-- TOC entry 1897 (class 0 OID 0)
-- Dependencies: 145
-- Name: element_text_element_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE element_text_element_id_seq OWNED BY element_text.element_id;


--
-- TOC entry 1898 (class 0 OID 0)
-- Dependencies: 145
-- Name: element_text_element_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('element_text_element_id_seq', 28, true);


--
-- TOC entry 146 (class 1259 OID 33054)
-- Dependencies: 6
-- Name: image_element; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE image_element (
    element_id integer NOT NULL,
    image_id integer NOT NULL,
    sec_id integer NOT NULL,
    element_order integer NOT NULL,
    ie_link_to text,
    gal_element_id integer
);


ALTER TABLE public.image_element OWNER TO postgres;

--
-- TOC entry 147 (class 1259 OID 33060)
-- Dependencies: 6 146
-- Name: image_element_element_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE image_element_element_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.image_element_element_id_seq OWNER TO postgres;

--
-- TOC entry 1899 (class 0 OID 0)
-- Dependencies: 147
-- Name: image_element_element_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE image_element_element_id_seq OWNED BY image_element.element_id;


--
-- TOC entry 1900 (class 0 OID 0)
-- Dependencies: 147
-- Name: image_element_element_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('image_element_element_id_seq', 20, true);


--
-- TOC entry 148 (class 1259 OID 33062)
-- Dependencies: 6
-- Name: images; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE images (
    image_id integer NOT NULL,
    image_file_name text NOT NULL
);


ALTER TABLE public.images OWNER TO postgres;

--
-- TOC entry 149 (class 1259 OID 33068)
-- Dependencies: 6 148
-- Name: images_image_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE images_image_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.images_image_id_seq OWNER TO postgres;

--
-- TOC entry 1901 (class 0 OID 0)
-- Dependencies: 149
-- Name: images_image_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE images_image_id_seq OWNED BY images.image_id;


--
-- TOC entry 1902 (class 0 OID 0)
-- Dependencies: 149
-- Name: images_image_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('images_image_id_seq', 21, true);


--
-- TOC entry 150 (class 1259 OID 33070)
-- Dependencies: 6
-- Name: menu_element; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE menu_element (
    element_id integer NOT NULL,
    sec_id integer NOT NULL,
    men_element_id integer,
    element_order integer NOT NULL,
    me_content text NOT NULL,
    me_link_to text
);


ALTER TABLE public.menu_element OWNER TO postgres;

--
-- TOC entry 151 (class 1259 OID 33076)
-- Dependencies: 150 6
-- Name: menu_element_element_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE menu_element_element_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.menu_element_element_id_seq OWNER TO postgres;

--
-- TOC entry 1903 (class 0 OID 0)
-- Dependencies: 151
-- Name: menu_element_element_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE menu_element_element_id_seq OWNED BY menu_element.element_id;


--
-- TOC entry 1904 (class 0 OID 0)
-- Dependencies: 151
-- Name: menu_element_element_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('menu_element_element_id_seq', 17, true);


--
-- TOC entry 152 (class 1259 OID 33078)
-- Dependencies: 6
-- Name: menu_list; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE menu_list (
    element_id integer NOT NULL,
    sec_id integer NOT NULL,
    element_order integer NOT NULL
);


ALTER TABLE public.menu_list OWNER TO postgres;

--
-- TOC entry 153 (class 1259 OID 33081)
-- Dependencies: 6 152
-- Name: menu_list_element_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE menu_list_element_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.menu_list_element_id_seq OWNER TO postgres;

--
-- TOC entry 1905 (class 0 OID 0)
-- Dependencies: 153
-- Name: menu_list_element_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE menu_list_element_id_seq OWNED BY menu_list.element_id;


--
-- TOC entry 1906 (class 0 OID 0)
-- Dependencies: 153
-- Name: menu_list_element_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('menu_list_element_id_seq', 10, true);


--
-- TOC entry 154 (class 1259 OID 33083)
-- Dependencies: 6
-- Name: sections; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE sections (
    sec_id integer NOT NULL,
    app_id integer NOT NULL,
    sec_name text NOT NULL,
    sec_date_created date NOT NULL,
    sec_date_updated date
);


ALTER TABLE public.sections OWNER TO postgres;

--
-- TOC entry 155 (class 1259 OID 33089)
-- Dependencies: 154 6
-- Name: sections_sec_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE sections_sec_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.sections_sec_id_seq OWNER TO postgres;

--
-- TOC entry 1907 (class 0 OID 0)
-- Dependencies: 155
-- Name: sections_sec_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE sections_sec_id_seq OWNED BY sections.sec_id;


--
-- TOC entry 1908 (class 0 OID 0)
-- Dependencies: 155
-- Name: sections_sec_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('sections_sec_id_seq', 21, true);


--
-- TOC entry 156 (class 1259 OID 33091)
-- Dependencies: 6
-- Name: users; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE users (
    user_id integer NOT NULL,
    user_name text NOT NULL,
    user_password text NOT NULL,
    user_email text NOT NULL
);


ALTER TABLE public.users OWNER TO postgres;

--
-- TOC entry 157 (class 1259 OID 33097)
-- Dependencies: 6 156
-- Name: users_user_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE users_user_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.users_user_id_seq OWNER TO postgres;

--
-- TOC entry 1909 (class 0 OID 0)
-- Dependencies: 157
-- Name: users_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE users_user_id_seq OWNED BY users.user_id;


--
-- TOC entry 1910 (class 0 OID 0)
-- Dependencies: 157
-- Name: users_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('users_user_id_seq', 4, true);


--
-- TOC entry 1828 (class 2604 OID 33099)
-- Dependencies: 143 142
-- Name: app_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY applications ALTER COLUMN app_id SET DEFAULT nextval('applications_app_id_seq'::regclass);


--
-- TOC entry 1829 (class 2604 OID 33100)
-- Dependencies: 145 144
-- Name: element_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY element_text ALTER COLUMN element_id SET DEFAULT nextval('element_text_element_id_seq'::regclass);


--
-- TOC entry 1827 (class 2604 OID 33101)
-- Dependencies: 141 140
-- Name: element_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY gallery_element ALTER COLUMN element_id SET DEFAULT nextval('"GALLERY_ELEMENT_ELEMENT_ID_seq"'::regclass);


--
-- TOC entry 1830 (class 2604 OID 33102)
-- Dependencies: 147 146
-- Name: element_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY image_element ALTER COLUMN element_id SET DEFAULT nextval('image_element_element_id_seq'::regclass);


--
-- TOC entry 1831 (class 2604 OID 33103)
-- Dependencies: 149 148
-- Name: image_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY images ALTER COLUMN image_id SET DEFAULT nextval('images_image_id_seq'::regclass);


--
-- TOC entry 1832 (class 2604 OID 33104)
-- Dependencies: 151 150
-- Name: element_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY menu_element ALTER COLUMN element_id SET DEFAULT nextval('menu_element_element_id_seq'::regclass);


--
-- TOC entry 1833 (class 2604 OID 33105)
-- Dependencies: 153 152
-- Name: element_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY menu_list ALTER COLUMN element_id SET DEFAULT nextval('menu_list_element_id_seq'::regclass);


--
-- TOC entry 1834 (class 2604 OID 33106)
-- Dependencies: 155 154
-- Name: sec_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY sections ALTER COLUMN sec_id SET DEFAULT nextval('sections_sec_id_seq'::regclass);


--
-- TOC entry 1835 (class 2604 OID 33107)
-- Dependencies: 157 156
-- Name: user_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY users ALTER COLUMN user_id SET DEFAULT nextval('users_user_id_seq'::regclass);


--
-- TOC entry 1880 (class 0 OID 33038)
-- Dependencies: 142
-- Data for Name: applications; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO applications (app_id, image_id, user_id, app_description, app_name, app_version, app_date_created, app_date_updated) VALUES (1, 1, 1, '', 'Paris', '2.0', '2013-06-09', '2013-06-09');
INSERT INTO applications (app_id, image_id, user_id, app_description, app_name, app_version, app_date_created, app_date_updated) VALUES (12, 18, 1, NULL, 'Metro Ccs Movil', '1.0', '2013-07-01', '2013-07-01');
INSERT INTO applications (app_id, image_id, user_id, app_description, app_name, app_version, app_date_created, app_date_updated) VALUES (13, 19, 4, 'Defensa de TEG', 'UCAB Movil', '0.1', '2013-07-17', '2013-07-17');


--
-- TOC entry 1881 (class 0 OID 33046)
-- Dependencies: 144
-- Data for Name: element_text; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO element_text (element_id, sec_id, element_order, text_content) VALUES (1, 1, 2, '<div style="text-align: center;"><br></div><div style="text-align: center;"><br></div><div style="text-align: center;"><br></div><div style="text-align: center;"><br></div><div style="text-align: center;"><br></div><div style="text-align: center;"><br></div><div style="text-align: center;">Bienvenido a mi aplicación =).</div>');
INSERT INTO element_text (element_id, sec_id, element_order, text_content) VALUES (23, 16, 2, '<div style="text-align: center;"><i style="color: rgb(255, 0, 0); font-size: x-large;"><b>------</b></i><font size="5" color="#ff0000"><i><b>&nbsp;Noticias ------</b></i></font></div><div style="text-align: center;"><br></div><div style="text-align: center;"><img src="http://www.metrodecaracas.com.ve/noticias/historial/2013/junio/imag/vacbellomonte2.png"></div><div style="text-align: center;">- Culmina en tiempo record vaciado de concentro en la estacion Bello Monte de Linea 5:&nbsp;</div><div style="text-align: center;">Para ver mas haga clic <a href="http://www.metrodecaracas.com.ve/noticias/historial/2013/junio/linea5.html">aqui</a></div><div style="text-align: center;"><br></div><div style="text-align: center;"><img src="http://www.metrodecaracas.com.ve/noticias/historial/2013/junio/imag/cabletren.png"></div><div style="text-align: center;">- Cabletren Bolivariano, sera inaugurado a finales de Julio.</div><div style="text-align: center;">Para ver mas haga clic <a href="http://www.metrodecaracas.com.ve/noticias/historial/2013/junio/cabletren_inaug.html">aqui</a></div><div style="text-align: center;"><br></div><div style="text-align: center;"><img src="http://www.metrodecaracas.com.ve/noticias/historial/2013/junio/imag/vive_danza.png"></div><div style="text-align: center;">- Usuarios del Metro bailaron al ritmo de Viva la Danza.</div><div style="text-align: center;">Para ver mas haga clic <a href="http://www.metrodecaracas.com.ve/noticias/historial/2013/junio/viva_danza.html">aqui</a></div>');
INSERT INTO element_text (element_id, sec_id, element_order, text_content) VALUES (24, 18, 1, '<div style="text-align: center;"><img src="http://t0.gstatic.com/images?q=tbn:ANd9GcTkqfr1CJkeB1APblYR1yBbf7Z7ViScbAM3oaac32hy2KWhD5Z2ifpRUA"><span class="Apple-tab-span" style="white-space:pre">	</span></div><div style="text-align: center;">Contacto!</div><div style="text-align: center;">Para mayor informacion puede comunicarse al +584129013621</div><div style="text-align: center;">Correo: jrodriguez@corpmobilesolutions.com</div>');
INSERT INTO element_text (element_id, sec_id, element_order, text_content) VALUES (27, 20, 2, '<div style="text-align: center;"><br></div><div style="text-align: center;"><img src=""></div><div style="text-align: center;"><br></div><div style="text-align: center;"><b><font size="5">¡ La UCAB Celebra sus 60 años !</font></b></div><div style="text-align: center;"><b><font size="5"><br></font></b></div><div style="text-align: center;"><span style="color: rgb(102, 102, 102); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 13px; text-align: left; background-color: rgb(255, 255, 255);">Alrededor de sesenta y seis mil profesionales han sido formados en la Universidad Católica Andres Bello a lo largo de sesenta años de historia, y asegurarse de que éstos sigan en contacto con su&nbsp;</span><i style="margin: 0px; padding: 0px; outline: 0px; border: 0px; color: rgb(102, 102, 102); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 13px; text-align: left; background-color: rgb(255, 255, 255);">alma mater</i><span style="color: rgb(102, 102, 102); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 13px; text-align: left; background-color: rgb(255, 255, 255);">&nbsp;ha sido siempre uno de los objetivos de esta casa de estudios.</span><br style="margin: 0px; padding: 0px; outline: 0px; border: 0px; color: rgb(102, 102, 102); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 13px; text-align: left; background-color: rgb(255, 255, 255);"><br style="margin: 0px; padding: 0px; outline: 0px; border: 0px; color: rgb(102, 102, 102); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 13px; text-align: left; background-color: rgb(255, 255, 255);"><span style="color: rgb(102, 102, 102); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 13px; text-align: left; background-color: rgb(255, 255, 255);">Por eso ayer el acto de celebración de sus sesenta años fue sobre todo un reencuentro de sus egresados, y a cada momento se recordó que es en gran parte gracias a la ayuda que éstos prestan que la universidad puede seguir llevando adelante sus programas sociales.&nbsp;</span></div>');
INSERT INTO element_text (element_id, sec_id, element_order, text_content) VALUES (25, 17, 2, '<div style="text-align: center;"><b>Estas son las imagenes que se muestran en esta seccion</b></div>');
INSERT INTO element_text (element_id, sec_id, element_order, text_content) VALUES (22, 15, 1, '<div style="text-align: center;"><font size="5">Bienvenido, a la aplicacion movil del Metro de Caracas.</font></div><div style="text-align: center;"><br></div><div style="text-align: center;"><img src="http://entrevecinospc.com/wp-content/uploads/2012/10/logo-del-metro-de-caracas.jpg"></div><div style="text-align: center;"><br></div><div style="text-align: center;">Esta aplicacion esta desarrollada para Android 4.2.2</div><div style="text-align: center;"><img src="https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcR_Yw_Ezy81grPOQfJCWDYQCShDvueFbUigKA7imNPEc3GhYOgD"></div><div style="text-align: center;"><br></div><div style="text-align: center;"><b><font size="6">-----------------------------------------------</font></b></div><div style="text-align: center;">Puedes ingresar a las secciones mediante el menu<b>, </b>puedes ingresar a la pagina <a href="http://www.metrodecaracas.com.ve/">aqui</a>:&nbsp;</div><div style="text-align: center;"><br></div><div style="text-align: center;"><img src="https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcT7-9p2XvlrnbbwwL0zVr5x_LLV4OoSs4mSk3xnwoih71CAexkTvAoUWT30">&nbsp;<span class="Apple-tab-span" style="white-space:pre">	</span><img src="http://t0.gstatic.com/images?q=tbn:ANd9GcRwRVsKtrKha4v2wiecSLkwNr0WKjP2R3zPYM7jQeHTVykhXaNkfL6o1g"></div><div style="text-align: center;">Galeria de imagenes / Las noticias mas actuales</div><div style="text-align: center;"><br></div><div style="text-align: center;"><img src="http://media.movidamovil.com/img/publicador/articulos/ministerio-del-pp-para-el-transporte-terrestre_grande.jpg"></div><div style="text-align: center;">Y muchas cosas mas, descubrelas! Metro de Caracas C.A - Somos parte de tu vida!</div>');
INSERT INTO element_text (element_id, sec_id, element_order, text_content) VALUES (26, 19, 2, '<div style="text-align: center;"><b><font size="5">Hola! haz clic <a href="http://www.google.com">aqui</a></font></b></div>');


--
-- TOC entry 1879 (class 0 OID 33033)
-- Dependencies: 140
-- Data for Name: gallery_element; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO gallery_element (element_id, sec_id, element_order) VALUES (1, 1, 1);
INSERT INTO gallery_element (element_id, sec_id, element_order) VALUES (4, 17, 3);
INSERT INTO gallery_element (element_id, sec_id, element_order) VALUES (5, 19, 3);
INSERT INTO gallery_element (element_id, sec_id, element_order) VALUES (8, 20, 3);


--
-- TOC entry 1882 (class 0 OID 33054)
-- Dependencies: 146
-- Data for Name: image_element; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO image_element (element_id, image_id, sec_id, element_order, ie_link_to, gal_element_id) VALUES (1, 2, 1, 1, '', 1);
INSERT INTO image_element (element_id, image_id, sec_id, element_order, ie_link_to, gal_element_id) VALUES (2, 3, 1, 2, '', 1);
INSERT INTO image_element (element_id, image_id, sec_id, element_order, ie_link_to, gal_element_id) VALUES (8, 6, 17, 1, '', 4);
INSERT INTO image_element (element_id, image_id, sec_id, element_order, ie_link_to, gal_element_id) VALUES (10, 18, 17, 3, '', 4);
INSERT INTO image_element (element_id, image_id, sec_id, element_order, ie_link_to, gal_element_id) VALUES (11, 6, 19, 1, '', 5);
INSERT INTO image_element (element_id, image_id, sec_id, element_order, ie_link_to, gal_element_id) VALUES (13, 18, 19, 3, '', 5);
INSERT INTO image_element (element_id, image_id, sec_id, element_order, ie_link_to, gal_element_id) VALUES (18, 21, 20, 1, '', 8);
INSERT INTO image_element (element_id, image_id, sec_id, element_order, ie_link_to, gal_element_id) VALUES (19, 19, 20, 2, '', 8);
INSERT INTO image_element (element_id, image_id, sec_id, element_order, ie_link_to, gal_element_id) VALUES (20, 20, 20, 3, '', 8);


--
-- TOC entry 1883 (class 0 OID 33062)
-- Dependencies: 148
-- Data for Name: images; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO images (image_id, image_file_name) VALUES (1, 'CIMG0932.JPG');
INSERT INTO images (image_id, image_file_name) VALUES (2, 'CIMG0928.JPG');
INSERT INTO images (image_id, image_file_name) VALUES (3, 'CIMG0931.JPG');
INSERT INTO images (image_id, image_file_name) VALUES (4, 'CIMG0959.JPG');
INSERT INTO images (image_id, image_file_name) VALUES (5, '');
INSERT INTO images (image_id, image_file_name) VALUES (6, 'IMG_20130511_150623.jpg');
INSERT INTO images (image_id, image_file_name) VALUES (7, 'mejor equipo.jpg');
INSERT INTO images (image_id, image_file_name) VALUES (8, 'mejor equipo.jpg');
INSERT INTO images (image_id, image_file_name) VALUES (9, 'mejor equipo.jpg');
INSERT INTO images (image_id, image_file_name) VALUES (10, 'mejor equipo.jpg');
INSERT INTO images (image_id, image_file_name) VALUES (11, 'mejor equipo.jpg');
INSERT INTO images (image_id, image_file_name) VALUES (12, 'mejor equipo.jpg');
INSERT INTO images (image_id, image_file_name) VALUES (13, 'mejor equipo.jpg');
INSERT INTO images (image_id, image_file_name) VALUES (14, 'mejor equipo.jpg');
INSERT INTO images (image_id, image_file_name) VALUES (15, 'mejor equipo.jpg');
INSERT INTO images (image_id, image_file_name) VALUES (16, 'mejor equipo.jpg');
INSERT INTO images (image_id, image_file_name) VALUES (17, 'mejor equipo.jpg');
INSERT INTO images (image_id, image_file_name) VALUES (18, 'metroMovil.jpg');
INSERT INTO images (image_id, image_file_name) VALUES (19, 'img_LogoUCAB.gif');
INSERT INTO images (image_id, image_file_name) VALUES (20, 'ucab.gif');
INSERT INTO images (image_id, image_file_name) VALUES (21, 'biblio.jpg');


--
-- TOC entry 1884 (class 0 OID 33070)
-- Dependencies: 150
-- Data for Name: menu_element; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO menu_element (element_id, sec_id, men_element_id, element_order, me_content, me_link_to) VALUES (1, 1, 1, 1, 'Home', 'Bienvenida');
INSERT INTO menu_element (element_id, sec_id, men_element_id, element_order, me_content, me_link_to) VALUES (2, 1, 1, 2, 'News', 'Noticias');
INSERT INTO menu_element (element_id, sec_id, men_element_id, element_order, me_content, me_link_to) VALUES (5, 15, 4, 1, 'Inicio', 'Bienvenida');
INSERT INTO menu_element (element_id, sec_id, men_element_id, element_order, me_content, me_link_to) VALUES (6, 15, 4, 2, 'Noticias', 'Noticias');
INSERT INTO menu_element (element_id, sec_id, men_element_id, element_order, me_content, me_link_to) VALUES (7, 15, 4, 3, 'Fotos', 'Galeria');
INSERT INTO menu_element (element_id, sec_id, men_element_id, element_order, me_content, me_link_to) VALUES (8, 15, 4, 4, 'Contacto', 'Contacto');
INSERT INTO menu_element (element_id, sec_id, men_element_id, element_order, me_content, me_link_to) VALUES (9, 16, 5, 1, 'Home', 'Bienvenida');
INSERT INTO menu_element (element_id, sec_id, men_element_id, element_order, me_content, me_link_to) VALUES (10, 17, 6, 1, 'Home', 'Bienvenida');
INSERT INTO menu_element (element_id, sec_id, men_element_id, element_order, me_content, me_link_to) VALUES (11, 18, 7, 1, 'Home', 'Bienvenida');
INSERT INTO menu_element (element_id, sec_id, men_element_id, element_order, me_content, me_link_to) VALUES (12, 19, 8, 1, 'Inicio', 'Bienvenida');
INSERT INTO menu_element (element_id, sec_id, men_element_id, element_order, me_content, me_link_to) VALUES (15, 20, 9, 1, 'Principal', 'Bienvenida');
INSERT INTO menu_element (element_id, sec_id, men_element_id, element_order, me_content, me_link_to) VALUES (16, 20, 9, 2, 'Escuelas', 'Escuelas');
INSERT INTO menu_element (element_id, sec_id, men_element_id, element_order, me_content, me_link_to) VALUES (17, 21, 10, 1, 'Inicio', 'Bienvenida');


--
-- TOC entry 1885 (class 0 OID 33078)
-- Dependencies: 152
-- Data for Name: menu_list; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO menu_list (element_id, sec_id, element_order) VALUES (1, 1, 3);
INSERT INTO menu_list (element_id, sec_id, element_order) VALUES (5, 16, 1);
INSERT INTO menu_list (element_id, sec_id, element_order) VALUES (7, 18, 2);
INSERT INTO menu_list (element_id, sec_id, element_order) VALUES (6, 17, 1);
INSERT INTO menu_list (element_id, sec_id, element_order) VALUES (4, 15, 2);
INSERT INTO menu_list (element_id, sec_id, element_order) VALUES (8, 19, 1);
INSERT INTO menu_list (element_id, sec_id, element_order) VALUES (10, 21, 1);
INSERT INTO menu_list (element_id, sec_id, element_order) VALUES (9, 20, 1);


--
-- TOC entry 1886 (class 0 OID 33083)
-- Dependencies: 154
-- Data for Name: sections; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO sections (sec_id, app_id, sec_name, sec_date_created, sec_date_updated) VALUES (1, 1, 'Bienvenida', '2013-06-09', '2013-06-09');
INSERT INTO sections (sec_id, app_id, sec_name, sec_date_created, sec_date_updated) VALUES (2, 1, 'Galeria', '2013-06-23', '2013-06-23');
INSERT INTO sections (sec_id, app_id, sec_name, sec_date_created, sec_date_updated) VALUES (15, 12, 'Bienvenida', '2013-07-01', '2013-07-01');
INSERT INTO sections (sec_id, app_id, sec_name, sec_date_created, sec_date_updated) VALUES (16, 12, 'Noticias', '2013-07-01', '2013-07-01');
INSERT INTO sections (sec_id, app_id, sec_name, sec_date_created, sec_date_updated) VALUES (17, 12, 'Galeria', '2013-07-01', '2013-07-01');
INSERT INTO sections (sec_id, app_id, sec_name, sec_date_created, sec_date_updated) VALUES (18, 12, 'Contacto', '2013-07-01', '2013-07-01');
INSERT INTO sections (sec_id, app_id, sec_name, sec_date_created, sec_date_updated) VALUES (19, 12, 'Novedades', '2013-07-01', '2013-07-01');
INSERT INTO sections (sec_id, app_id, sec_name, sec_date_created, sec_date_updated) VALUES (20, 13, 'Bienvenida', '2013-07-17', '2013-07-17');
INSERT INTO sections (sec_id, app_id, sec_name, sec_date_created, sec_date_updated) VALUES (21, 13, 'Escuelas', '2013-07-21', '2013-07-21');


--
-- TOC entry 1887 (class 0 OID 33091)
-- Dependencies: 156
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO users (user_id, user_name, user_password, user_email) VALUES (1, 'Jose Luis', '123456', 'jrodriguez@gmail.com');
INSERT INTO users (user_id, user_name, user_password, user_email) VALUES (2, 'vhernandez', '123456', 'vhernandez@gmail.com');
INSERT INTO users (user_id, user_name, user_password, user_email) VALUES (3, 'jgrillo', '123456', 'jgrillo@gmail.com');
INSERT INTO users (user_id, user_name, user_password, user_email) VALUES (4, 'grodriguez', '123456', 'grodriguez@gmail.com');


--
-- TOC entry 1837 (class 2606 OID 33109)
-- Dependencies: 140 140
-- Name: gallery_element_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY gallery_element
    ADD CONSTRAINT gallery_element_pkey PRIMARY KEY (element_id);


--
-- TOC entry 1840 (class 2606 OID 33111)
-- Dependencies: 142 142
-- Name: pk_applications; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY applications
    ADD CONSTRAINT pk_applications PRIMARY KEY (app_id);


--
-- TOC entry 1845 (class 2606 OID 33113)
-- Dependencies: 144 144
-- Name: pk_element_text; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY element_text
    ADD CONSTRAINT pk_element_text PRIMARY KEY (element_id);


--
-- TOC entry 1848 (class 2606 OID 33115)
-- Dependencies: 146 146
-- Name: pk_image_element; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY image_element
    ADD CONSTRAINT pk_image_element PRIMARY KEY (element_id);


--
-- TOC entry 1851 (class 2606 OID 33117)
-- Dependencies: 148 148
-- Name: pk_images; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY images
    ADD CONSTRAINT pk_images PRIMARY KEY (image_id);


--
-- TOC entry 1854 (class 2606 OID 33119)
-- Dependencies: 150 150
-- Name: pk_menu_element; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY menu_element
    ADD CONSTRAINT pk_menu_element PRIMARY KEY (element_id);


--
-- TOC entry 1859 (class 2606 OID 33121)
-- Dependencies: 152 152
-- Name: pk_menu_list; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY menu_list
    ADD CONSTRAINT pk_menu_list PRIMARY KEY (element_id);


--
-- TOC entry 1862 (class 2606 OID 33123)
-- Dependencies: 154 154
-- Name: pk_sections; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY sections
    ADD CONSTRAINT pk_sections PRIMARY KEY (sec_id);


--
-- TOC entry 1866 (class 2606 OID 33125)
-- Dependencies: 156 156
-- Name: pk_users; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY users
    ADD CONSTRAINT pk_users PRIMARY KEY (user_id);


--
-- TOC entry 1838 (class 1259 OID 33126)
-- Dependencies: 142
-- Name: applications_pk; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE UNIQUE INDEX applications_pk ON applications USING btree (app_id);


--
-- TOC entry 1843 (class 1259 OID 33127)
-- Dependencies: 144
-- Name: element_text_pk; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE UNIQUE INDEX element_text_pk ON element_text USING btree (element_id);


--
-- TOC entry 1849 (class 1259 OID 33128)
-- Dependencies: 148
-- Name: images_pk; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE UNIQUE INDEX images_pk ON images USING btree (image_id);


--
-- TOC entry 1852 (class 1259 OID 33129)
-- Dependencies: 150
-- Name: menu_element_pk; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE UNIQUE INDEX menu_element_pk ON menu_element USING btree (element_id);


--
-- TOC entry 1857 (class 1259 OID 33130)
-- Dependencies: 152
-- Name: menu_list_pk; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE UNIQUE INDEX menu_list_pk ON menu_list USING btree (element_id);


--
-- TOC entry 1841 (class 1259 OID 33131)
-- Dependencies: 142
-- Name: relationship_1_fk; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX relationship_1_fk ON applications USING btree (user_id);


--
-- TOC entry 1842 (class 1259 OID 33132)
-- Dependencies: 142
-- Name: relationship_2_fk; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX relationship_2_fk ON applications USING btree (image_id);


--
-- TOC entry 1863 (class 1259 OID 33133)
-- Dependencies: 154
-- Name: relationship_3_fk; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX relationship_3_fk ON sections USING btree (app_id);


--
-- TOC entry 1846 (class 1259 OID 33134)
-- Dependencies: 144
-- Name: relationship_4_fk; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX relationship_4_fk ON element_text USING btree (sec_id);


--
-- TOC entry 1855 (class 1259 OID 33135)
-- Dependencies: 150
-- Name: relationship_5_fk; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX relationship_5_fk ON menu_element USING btree (men_element_id);


--
-- TOC entry 1856 (class 1259 OID 33136)
-- Dependencies: 150
-- Name: relationship_6_fk; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX relationship_6_fk ON menu_element USING btree (sec_id);


--
-- TOC entry 1860 (class 1259 OID 33137)
-- Dependencies: 152
-- Name: relationship_7_fk; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX relationship_7_fk ON menu_list USING btree (sec_id);


--
-- TOC entry 1864 (class 1259 OID 33138)
-- Dependencies: 154
-- Name: sections_pk; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE UNIQUE INDEX sections_pk ON sections USING btree (sec_id);


--
-- TOC entry 1867 (class 1259 OID 33139)
-- Dependencies: 156
-- Name: users_pk; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE UNIQUE INDEX users_pk ON users USING btree (user_id);


--
-- TOC entry 1869 (class 2606 OID 33140)
-- Dependencies: 1850 142 148
-- Name: fk_applicat_relations_images; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY applications
    ADD CONSTRAINT fk_applicat_relations_images FOREIGN KEY (image_id) REFERENCES images(image_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- TOC entry 1870 (class 2606 OID 33145)
-- Dependencies: 142 1865 156
-- Name: fk_applicat_relations_users; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY applications
    ADD CONSTRAINT fk_applicat_relations_users FOREIGN KEY (user_id) REFERENCES users(user_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- TOC entry 1871 (class 2606 OID 33150)
-- Dependencies: 1861 154 144
-- Name: fk_element__relations_sections; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY element_text
    ADD CONSTRAINT fk_element__relations_sections FOREIGN KEY (sec_id) REFERENCES sections(sec_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- TOC entry 1872 (class 2606 OID 33155)
-- Dependencies: 148 1850 146
-- Name: fk_image_el_relations_images; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY image_element
    ADD CONSTRAINT fk_image_el_relations_images FOREIGN KEY (image_id) REFERENCES images(image_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- TOC entry 1873 (class 2606 OID 33160)
-- Dependencies: 146 1861 154
-- Name: fk_image_el_relations_sections; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY image_element
    ADD CONSTRAINT fk_image_el_relations_sections FOREIGN KEY (sec_id) REFERENCES sections(sec_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- TOC entry 1875 (class 2606 OID 33165)
-- Dependencies: 152 1858 150
-- Name: fk_menu_ele_relations_menu_lis; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY menu_element
    ADD CONSTRAINT fk_menu_ele_relations_menu_lis FOREIGN KEY (men_element_id) REFERENCES menu_list(element_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- TOC entry 1876 (class 2606 OID 33170)
-- Dependencies: 150 154 1861
-- Name: fk_menu_ele_relations_sections; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY menu_element
    ADD CONSTRAINT fk_menu_ele_relations_sections FOREIGN KEY (sec_id) REFERENCES sections(sec_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- TOC entry 1877 (class 2606 OID 33175)
-- Dependencies: 1861 152 154
-- Name: fk_menu_lis_relations_sections; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY menu_list
    ADD CONSTRAINT fk_menu_lis_relations_sections FOREIGN KEY (sec_id) REFERENCES sections(sec_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- TOC entry 1878 (class 2606 OID 33180)
-- Dependencies: 1839 154 142
-- Name: fk_sections_relations_applicat; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY sections
    ADD CONSTRAINT fk_sections_relations_applicat FOREIGN KEY (app_id) REFERENCES applications(app_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- TOC entry 1868 (class 2606 OID 33185)
-- Dependencies: 154 1861 140
-- Name: gallery_element_SEC_ID_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY gallery_element
    ADD CONSTRAINT "gallery_element_SEC_ID_fkey" FOREIGN KEY (sec_id) REFERENCES sections(sec_id);


--
-- TOC entry 1874 (class 2606 OID 33190)
-- Dependencies: 1836 146 140
-- Name: image_element_gal_element_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY image_element
    ADD CONSTRAINT image_element_gal_element_id_fkey FOREIGN KEY (gal_element_id) REFERENCES gallery_element(element_id);


--
-- TOC entry 1892 (class 0 OID 0)
-- Dependencies: 6
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


-- Completed on 2013-08-08 06:43:20

--
-- PostgreSQL database dump complete
--

